Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ConversionStateCode (PK) | A code used to designate the conversion status or condition of a party. (See ConversionState ET definition) | CD_CVN_ST | Code | varchar(20) | |
Parent (FK) | A code used to designate the conversion status or condition of a party. (See ConversionState ET definition) | CD_PRNT_CVN_ST | Code | varchar(20) | ConversionState(CO_CVN_ST) |
ConversionStateDescription | A short narrative description of a given ConversionState | DE_CVN_ST | DescriptionShort | varchar(255) | |
RelativeLowToHighValue | An integer value that defines the relative value of a given conversion state to a retailer's business. This is intended to provide a way to order the listing of conversion states from lowest value to highest value (or the reverse). It is a value assigned by each retailer. No two conversion states should have the same RelativeLowToHighValue. The purpose of this is to use in tracking party state changes as they advance (or retreat) to states that are more or less valuable to the retailer. This is an important dimension when monitoring and managing customer lifecycles. | VL_RLTV_LW_TO_HIGH | LineNumber | smallint | |
RelationshipStageCode (FK) | Code that identifies a partiular stage of development for customer conversion analysis. A list of proposed stages is provided in the entity definition. This code may be assigned by the retailer. ARTS recommends at least four stages: CUST_ACQUISITION CUSTOMER INACTIVE_CUSTOMER EX_CUSTOMER Retailers may define their own codes. | CD_RLTN_STG | Code | varchar(20) | RelationshipStage(CO_RLtN_Stg) |